﻿using System;

namespace Jb.Domain
{
    public static class DbObject
    {
        /// <summary>
        /// Contains the Names of the Stored Procedures
        /// Stored Procedure's names should not be prefixed with dob. as SQL Server.
        /// It is interpreted as DatabaseName.Procedure name and hence produces 
        /// Procedure not found exception in MySQL
        /// </summary>
        public static class SP
        {
            public const String GET_PAGED_JOB_LIST_BY_COMPANY = "GetPagedJobListByCompany";            

            //public const String GET_CONTENT = "dbo.GetContentList";
            public const String GET_LOOKUP_DATA = "GetLookupData";
            public const String GET_RESUMES_BY_JOBSEEKER = "GetResumesByJobSeeker";
            public const String GET_COVERLETTERS_BY_JOBSEEKER = "GetCoverLettersByJobSeeker";

            public const String GET_PAGED_JOBS_BY_ID = "GetPagedJobsByID";
            public const String GET_PAGED_FAVOURITE_RESUME_LIST = "GetPagedFavoriteResumeList"; ///Not Implemented yet
            public const String GET_PAGED_RESUMES_BY_ID = "GetPagedResumesByID";
            public const String GET_PACKAGE_LIST = "GetPackageList";
            public const String GET_FEATURED_JOBS_BY_COMPANY = "GetFeaturedJobsByCompany"; //Can Get jobs of all companies if companyID=0
            public const String GET_CONTACTS_BY_COMPANY = "GetContactsByCompany";
            public const String GET_FAVORITE_JOBS_BY_JOBSEEKER = "GetFavoriteJobsByJobSeeker";
        }

        /// <summary>
        /// Contains the Names of the Database Functions
        /// </summary>
        public static class Function
        {
            
        }
        
        /// <summary>
        /// Conntains the Names of the Database Views
        /// </summary>
        public static class View
        {

        }
    }
}
